/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package Modelo;

import Controlador.ConnectionDB;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author brayitan
 */
public class Report extends HttpServlet {

    /**
     * Processes requests for both HTTP
     * <code>GET</code> and
     * <code>POST</code> methods.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {        
        response.setContentType("text/xml;charset=UTF-8");
        PrintWriter out = response.getWriter();
        try {
            out.println("<?xml version=\"1.0\"?>");
            out.println("<AgentStatistics>");
            ConnectionDB connectionDB = new ConnectionDB();
            if(connectionDB.Connect()){
                try{
                    ResultSet resultSet = connectionDB.getQuery("SELECT A.IdAgent, A.Name, Ast.Data, Ast.Date FROM AgentStatistics Ast, Agent A WHERE A.IdAgent = Ast.Agent");
                    while(resultSet.next()){
                        out.println("<Agent>");
                        out.println("<Id>" + resultSet.getInt(1) + "</Id>");
                        out.println("<Name>" + resultSet.getString(2) + "</Name>");
                        out.println("<Data>" + resultSet.getString(3) + "</Data>");
                        //out.println("<Date>" + DateFormat.getDateTimeInstance().format(new Date(resultSet.getTimestamp(4).getTime())) + "</Date>");
                        out.println("<Date>" + resultSet.getTimestamp(4).getTime() + "</Date>");
                        out.println("</Agent>");
                    }
                }
                catch(SQLException ex){
                }
            }
            out.println("</AgentStatistics>");
        } finally {            
            out.close();
        }
    }
    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
    /**
     * Handles the HTTP
     * <code>GET</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Handles the HTTP
     * <code>POST</code> method.
     *
     * @param request servlet request
     * @param response servlet response
     * @throws ServletException if a servlet-specific error occurs
     * @throws IOException if an I/O error occurs
     */
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        processRequest(request, response);
    }

    /**
     * Returns a short description of the servlet.
     *
     * @return a String containing servlet description
     */
    @Override
    public String getServletInfo() {
        return "Short description";
    }// </editor-fold>
}
